2014-08-18 - 7319.300 - Spec - NEbyU Material Report #CrystalReportDevelopment
SPECIFICATION
7319.300 - NEbyU Material Report
Requirement Summary
Need to create a report showing totals of user created materials in New Era by You broken out by different criteria.
Admin Info
Purpose
|
Need to create a report showing totals of user created materials in New Era by You broken out by different criteria.
|
Requested By
|
Scott Follett
|
Spec Created By
|
Naga Brahmam R
|
Spec Created Date
|
08/18/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
New Era by You Fabric Report
New Era by You Logo Report
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
10
|
5
|
Unit test in QUA
|
06
|
6
|
Query Testing
|
16
|
|
TOTAL
|
80
|
References
Prior Tickets
None
Documents
functional_spec_nebyu_fabric.docx
technical_spec_nebyu_fabric.docx
functional_spec_nebyu_logos.docx
technical_spec_nebyu_logos.docx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
These reports need to analyze color performance and logo usage to help make informed future product decisions.
Purpose/WHY:
08-18-2014 - Email from Aaron Ortwein - NEC requested us to work on the following requirement:I have a request for 2 new Crystal reports. I’ve attached the functional and technical specs. One report is New Era by You Fabric Usage, and New Era by You Logo Usage. These reports will need to join data from our production New Era by You database and our production ROC database.
Data-source:
a. command data-source on NECCGWEBSQL1.NewEraByYou
b. command data-source on NECCGWEBSQL.ROC
In Scope:
One report is New Era by You Fabric Usage and other is New Era by You Logo Usage.
Out of Scope:
None
Solution Summary
1. Need to create 2 reports with same structure as specified in the technical specification.
2. Need to apply groupings as specified in the technical specification.
3. Need to display data in Grid/table format for each report.
4. Need to apply formatting for each report as specified by NEC.
5. Need to apply sort order at the group level by Year.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
01
|
Need to test whether the report data validates with SQL Query.
|
Data should be validated successfully.
|
02
|
Schedule the Reports in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
03
|
Check report against the Crystal reports standard checklist.
|
Report should pass all standard test cases.
|
Solution Details
1. Need to create 2 reports with same structure as specified in the technical specification.
2. Need to apply groupings as specified in the technical specification. i.e
New Era by You Fabric Report: Year > Fabric Content > Color > Silhouette.
New Era by You Logo Report: Year > License > Team > Logo > Silhouette.
3. Need to apply formatting for each report as specified by NEC.
4. Need to apply sort order at the group level by Year(old to new).
Issues
None